


SELECT     de_meterId, de_kWhDaily,  MAX(de_kWhTotal) AS Reading, MAX(de_dateTime) AS ReadingDate
FROM         ElectricityDaily_Manual
GROUP BY de_meterId, de_kWhDaily

ORDER BY de_meterId, ReadingDate
